﻿CREATE PROCEDURE [dbo].[sp_public_getClassesByRace]
	@Race_Id INT
AS
SELECT Classes.Class_Id, Classes.Class_Name
FROM Races_Classes_Relations INNER JOIN
     Races ON Races_Classes_Relations.Race2Class_Race = Races.Race_Id INNER JOIN
     Classes ON Races_Classes_Relations.Race2Class_Class = Classes.Class_Id
WHERE Races.Race_Id = @Race_Id

RETURN 0